Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	4028530
Missing cells	13523378
Missing cells (%)	18.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	553.2 MiB
Average record size in memory	144.0 B

Variable types

DateTime	2
Categorical	6
Text	7
Boolean	2
Numeric	1

Alerts

`Company public response` is highly imbalanced (77.4%)	Imbalance
`Submitted via` is highly imbalanced (72.1%)	Imbalance
`Company response to consumer` is highly imbalanced (59.8%)	Imbalance
`Timely response?` is highly imbalanced (89.8%)	Imbalance
`Sub-product` has 235291 (5.8%) missing values	Missing
`Sub-issue` has 715348 (17.8%) missing values	Missing
`Consumer complaint narrative` has 2568404 (63.8%) missing values	Missing
`Company public response` has 2168295 (53.8%) missing values	Missing
`State` has 43121 (1.1%) missing values	Missing
`Tags` has 3605729 (89.5%) missing values	Missing
`Consumer consent provided?` has 896805 (22.3%) missing values	Missing
`Consumer disputed?` has 3260172 (80.9%) missing values	Missing
`Complaint ID` has unique values	Unique

Reproduction

Analysis started	2023-09-24 07:11:27.692838
Analysis finished	2023-09-24 07:33:07.729547
Duration	21 minutes and 40.04 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

Date received
Date

Distinct	4295
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	30.7 MiB

Minimum	2011-12-01 00:00:00
Maximum	2023-09-05 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Product
Categorical

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	30.7 MiB

Credit reporting, credit repair services, or other personal consumer reports	2162845
Debt collection	503401
Mortgage	383137
Credit card or prepaid card	205725
Checking or savings account	180437
Other values (16)	592985

Length

Max length	76
Median length	76
Mean length	49.201466
Min length	8

Characters and Unicode

Total characters	198209580
Distinct characters	32
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Payday loan, title loan, or personal loan
2nd row	Credit reporting, credit repair services, or other personal consumer reports
3rd row	Credit reporting, credit repair services, or other personal consumer reports
4th row	Credit card or prepaid card
5th row	Credit reporting, credit repair services, or other personal consumer reports

Common Values

Value	Count	Frequency (%)
Credit reporting, credit repair services, or other personal consumer reports	2162845	53.7%
Debt collection	503401	12.5%
Mortgage	383137	9.5%
Credit card or prepaid card	205725	5.1%
Checking or savings account	180437	4.5%
Credit reporting	140429	3.5%
Credit card	89569	2.2%
Bank account or service	86205	2.1%
Student loan	76153	1.9%
Money transfer, virtual currency, or money service	58142	1.4%
Other values (11)	142487	3.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
credit	4778879	17.9%
or	2788469	10.4%
reporting	2320726	8.7%
consumer	2211872	8.3%
personal	2210866	8.3%
other	2181355	8.2%
reports	2180297	8.1%
repair	2162845	8.1%
services	2162845	8.1%
card	504845	1.9%
Other values (23)	3250264	12.1%

Most occurring characters

Value	Count	Frequency (%)
r	31206432	15.7%
e	24981675	12.6%
	22724733	11.5%
o	15922832	8.0%
t	13452966	6.8%
i	12782451	6.4%
s	11550934	5.8%
p	9290010	4.7%
c	9041262	4.6%
n	8534293	4.3%
Other values (22)	38721992	19.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	166921600	84.2%
Space Separator	22724733	11.5%
Other Punctuation	4503142	2.3%
Uppercase Letter	4060105	2.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	31206432	18.7%
e	24981675	15.0%
o	15922832	9.5%
t	13452966	8.1%
i	12782451	7.7%
s	11550934	6.9%
p	9290010	5.6%
c	9041262	5.4%
n	8534293	5.1%
a	6499774	3.9%
Other values (11)	23658971	14.2%

Uppercase Letter

Value	Count	Frequency (%)
C	2828032	69.7%
D	503415	12.4%
M	446633	11.0%
B	86205	2.1%
S	76153	1.9%
V	47098	1.2%
P	39936	1.0%
L	31575	0.8%
O	1058	< 0.1%

Space Separator

Value	Count	Frequency (%)
	22724733	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	4503142	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	170981705	86.3%
Common	27227875	13.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	31206432	18.3%
e	24981675	14.6%
o	15922832	9.3%
t	13452966	7.9%
i	12782451	7.5%
s	11550934	6.8%
p	9290010	5.4%
c	9041262	5.3%
n	8534293	5.0%
a	6499774	3.8%
Other values (20)	27719076	16.2%

Common

Value	Count	Frequency (%)
	22724733	83.5%
,	4503142	16.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	198209580	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	31206432	15.7%
e	24981675	12.6%
	22724733	11.5%
o	15922832	8.0%
t	13452966	6.8%
i	12782451	6.4%
s	11550934	5.8%
p	9290010	4.7%
c	9041262	4.6%
n	8534293	4.3%
Other values (22)	38721992	19.5%

Sub-product
Text

MISSING

Distinct	81
Distinct (%)	< 0.1%
Missing	235291
Missing (%)	5.8%
Memory size	30.7 MiB

Length

Max length	48
Median length	16
Mean length	17.986389
Min length	4

Characters and Unicode

Total characters	68226672
Distinct characters	53
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Installment loan
2nd row	Credit reporting
3rd row	Credit reporting
4th row	Store credit card
5th row	Credit reporting

Value	Count	Frequency (%)
credit	2493249	26.4%
reporting	2158991	22.9%
card	480872	5.1%
mortgage	373612	4.0%
other	299902	3.2%
debt	276648	2.9%
account	222131	2.4%
or	221277	2.3%
loan	216915	2.3%
checking	202775	2.2%
Other values (99)	2483290	26.3%

Most occurring characters

Value	Count	Frequency (%)
r	9138052	13.4%
e	7983617	11.7%
t	6790900	10.0%
i	5643616	8.3%
	5636423	8.3%
o	4561357	6.7%
n	4292072	6.3%
d	3789396	5.6%
g	3369469	4.9%
C	2696278	4.0%
Other values (43)	14325492	21.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	57862868	84.8%
Space Separator	5636423	8.3%
Uppercase Letter	4083048	6.0%
Other Punctuation	242512	0.4%
Dash Punctuation	192425	0.3%
Open Punctuation	104610	0.2%
Close Punctuation	104610	0.2%
Final Punctuation	176	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	9138052	15.8%
e	7983617	13.8%
t	6790900	11.7%
i	5643616	9.8%
o	4561357	7.9%
n	4292072	7.4%
d	3789396	6.5%
g	3369469	5.8%
p	2658396	4.6%
a	2364837	4.1%
Other values (15)	7271156	12.6%

Uppercase Letter

Value	Count	Frequency (%)
C	2696278	66.0%
O	309017	7.6%
G	179877	4.4%
I	144714	3.5%
M	134130	3.3%
A	107615	2.6%
F	94998	2.3%
H	78445	1.9%
S	65496	1.6%
L	56149	1.4%
Other values (9)	216329	5.3%

Other Punctuation

Value	Count	Frequency (%)
.	133572	55.1%
,	89049	36.7%
/	17925	7.4%
'	1966	0.8%

Space Separator

Value	Count	Frequency (%)
	5636423	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	192425	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	104610	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	104610	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	176	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	61945916	90.8%
Common	6280756	9.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	9138052	14.8%
e	7983617	12.9%
t	6790900	11.0%
i	5643616	9.1%
o	4561357	7.4%
n	4292072	6.9%
d	3789396	6.1%
g	3369469	5.4%
C	2696278	4.4%
p	2658396	4.3%
Other values (34)	11022763	17.8%

Common

Value	Count	Frequency (%)
	5636423	89.7%
-	192425	3.1%
.	133572	2.1%
(	104610	1.7%
)	104610	1.7%
,	89049	1.4%
/	17925	0.3%
'	1966	< 0.1%
’	176	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	68226496	> 99.9%
Punctuation	176	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	9138052	13.4%
e	7983617	11.7%
t	6790900	10.0%
i	5643616	8.3%
	5636423	8.3%
o	4561357	6.7%
n	4292072	6.3%
d	3789396	5.6%
g	3369469	4.9%
C	2696278	4.0%
Other values (42)	14325316	21.0%

Punctuation

Value	Count	Frequency (%)
’	176	100.0%

Issue
Text

Distinct	172
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	30.7 MiB

Length

Max length	80
Median length	63
Mean length	39.792752
Min length	4

Characters and Unicode

Total characters	160306295
Distinct characters	49
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Problem when making payments
2nd row	Incorrect information on your report
3rd row	Improper use of your report
4th row	Fees or interest
5th row	Problem with a credit reporting company's investigation into an existing problem

Value	Count	Frequency (%)
your	1755191	7.6%
report	1695376	7.3%
problem	1340534	5.8%
on	1211000	5.2%
information	1153754	5.0%
incorrect	1146671	4.9%
credit	837659	3.6%
an	782069	3.4%
a	752868	3.2%
with	739774	3.2%
Other values (242)	11802426	50.8%

Most occurring characters

Value	Count	Frequency (%)
	19188792	12.0%
o	17633335	11.0%
r	15735070	9.8%
t	13691377	8.5%
n	13042924	8.1%
e	12682822	7.9%
i	10917061	6.8%
a	6976578	4.4%
c	6446806	4.0%
p	5609440	3.5%
Other values (39)	38382090	23.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	135682703	84.6%
Space Separator	19188792	12.0%
Uppercase Letter	4097522	2.6%
Other Punctuation	1336193	0.8%
Dash Punctuation	1085	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	17633335	13.0%
r	15735070	11.6%
t	13691377	10.1%
n	13042924	9.6%
e	12682822	9.3%
i	10917061	8.0%
a	6976578	5.1%
c	6446806	4.8%
p	5609440	4.1%
m	4878390	3.6%
Other values (15)	28068900	20.7%

Uppercase Letter

Value	Count	Frequency (%)
I	1692878	41.3%
P	768824	18.8%
A	283051	6.9%
C	262660	6.4%
L	194635	4.8%
M	172862	4.2%
T	147137	3.6%
D	106869	2.6%
F	95947	2.3%
S	80628	2.0%
Other values (8)	292031	7.1%

Other Punctuation

Value	Count	Frequency (%)
'	697573	52.2%
,	569949	42.7%
/	67346	5.0%
.	1325	0.1%

Space Separator

Value	Count	Frequency (%)
	19188792	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1085	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	139780225	87.2%
Common	20526070	12.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	17633335	12.6%
r	15735070	11.3%
t	13691377	9.8%
n	13042924	9.3%
e	12682822	9.1%
i	10917061	7.8%
a	6976578	5.0%
c	6446806	4.6%
p	5609440	4.0%
m	4878390	3.5%
Other values (33)	32166422	23.0%

Common

Value	Count	Frequency (%)
	19188792	93.5%
'	697573	3.4%
,	569949	2.8%
/	67346	0.3%
.	1325	< 0.1%
-	1085	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	160306295	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	19188792	12.0%
o	17633335	11.0%
r	15735070	9.8%
t	13691377	8.5%
n	13042924	8.1%
e	12682822	7.9%
i	10917061	6.8%
a	6976578	4.4%
c	6446806	4.0%
p	5609440	3.5%
Other values (39)	38382090	23.9%

Sub-issue
Text

MISSING

Distinct	248
Distinct (%)	< 0.1%
Missing	715348
Missing (%)	17.8%
Memory size	30.7 MiB

Length

Max length	145
Median length	83
Mean length	38.881701
Min length	9

Characters and Unicode

Total characters	128822151
Distinct characters	56
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11 ?
Unique (%)	< 0.1%

Sample

1st row	Account information incorrect
2nd row	Reporting company used your report improperly
3rd row	Charged too much interest
4th row	Their investigation did not fix an error on your report
5th row	Attempted to collect wrong amount

Value	Count	Frequency (%)
information	1062112	5.3%
your	996501	5.0%
report	906798	4.5%
to	901711	4.5%
not	688665	3.4%
someone	684258	3.4%
else	684258	3.4%
belongs	684258	3.4%
investigation	572869	2.9%
on	556199	2.8%
Other values (446)	12254844	61.3%

Most occurring characters

Value	Count	Frequency (%)
	16679291	12.9%
o	14131660	11.0%
e	12115536	9.4%
t	10307649	8.0%
n	10126591	7.9%
r	10086882	7.8%
i	8273144	6.4%
s	5964596	4.6%
a	5287274	4.1%
u	3477121	2.7%
Other values (46)	32372407	25.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	108075810	83.9%
Space Separator	16679291	12.9%
Uppercase Letter	3395719	2.6%
Other Punctuation	391679	0.3%
Decimal Number	270380	0.2%
Dash Punctuation	9272	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	14131660	13.1%
e	12115536	11.2%
t	10307649	9.5%
n	10126591	9.4%
r	10086882	9.3%
i	8273144	7.7%
s	5964596	5.5%
a	5287274	4.9%
u	3477121	3.2%
m	3350326	3.1%
Other values (16)	24955031	23.1%

Uppercase Letter

Value	Count	Frequency (%)
I	880158	25.9%
T	435005	12.8%
D	400971	11.8%
R	388979	11.5%
A	353843	10.4%
C	334658	9.9%
P	242597	7.1%
W	95616	2.8%
F	61246	1.8%
O	60220	1.8%
Other values (11)	142426	4.2%

Decimal Number

Value	Count	Frequency (%)
3	132968	49.2%
0	132968	49.2%
8	2222	0.8%
9	2222	0.8%

Other Punctuation

Value	Count	Frequency (%)
'	344586	88.0%
,	29285	7.5%
/	17808	4.5%

Space Separator

Value	Count	Frequency (%)
	16679291	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	9272	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	111471529	86.5%
Common	17350622	13.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	14131660	12.7%
e	12115536	10.9%
t	10307649	9.2%
n	10126591	9.1%
r	10086882	9.0%
i	8273144	7.4%
s	5964596	5.4%
a	5287274	4.7%
u	3477121	3.1%
m	3350326	3.0%
Other values (37)	28350750	25.4%

Common

Value	Count	Frequency (%)
	16679291	96.1%
'	344586	2.0%
3	132968	0.8%
0	132968	0.8%
,	29285	0.2%
/	17808	0.1%
-	9272	0.1%
8	2222	< 0.1%
9	2222	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	128822151	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	16679291	12.9%
o	14131660	11.0%
e	12115536	9.4%
t	10307649	8.0%
n	10126591	7.9%
r	10086882	7.8%
i	8273144	6.4%
s	5964596	4.6%
a	5287274	4.1%
u	3477121	2.7%
Other values (46)	32372407	25.1%

Consumer complaint narrative
Text

MISSING

Distinct	1239244
Distinct (%)	84.9%
Missing	2568404
Missing (%)	63.8%
Memory size	30.7 MiB

Length

Max length	32616
Median length	17999
Mean length	1030.8442
Min length	4

Characters and Unicode

Total characters	1505162460
Distinct characters	130
Distinct categories	19 ?
Distinct scripts	3 ?
Distinct blocks	5 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1162008 ?
Unique (%)	79.6%

Sample

1st row	I do not have any knowledge of applying for a credit card with XXXX. Nor do I have a contract with the debt collector. I demand this inquiry be removed from my credit report.
2nd row	Checking account opened XX/XX/XXXX. I am a previous customer of BMO Harris ( last account closed XX/XX/XXXX ) and have existing login credentials. I attempted to log into my new account on XX/XX/XXXX using my existing login credentials and kept getting a message that my credentials weren't matching what they had on file. I called and spoke with CSR XXXX on XX/XX/XXXX. XXXX advised that I couldn't access my online account because my initial deposit hadn't yet hit the account, and to give it a couple days ; once my account was funded, I'd be able to access it. When I was still unable to access it on XX/XX/XXXX, I called again and spoke with CSR XXXX on XX/XX/XXXX. He looked into it and couldn't determine what the problem was ; he said he would open a ticket with their tech department and he would call me back in 2-3 business days to let me know the status. I never heard from him again. On XX/XX/XXXX, I called again, this time requesting to speak to a manager. I was transferred to, and spoke with, XXXX XXXX ( her phone number is XXXX ). She also could not determine what the problem was in my accessing the account ; she said she would submit an expedited request with the tech team and she assured me that she would call me back by the end of that day. I never heard from her again. I left voice mail messages for XXXX on XX/XX/XXXX, XX/XX/XXXX, and XX/XX/XXXX and never received a return call. As of this morning, I still can not access my online account, although two deposits have been made ( one of which is a payroll direct deposit ).
3rd row	I had workable credit card business relationship with Aspire credit card co. I sought to close my cc acct back in XXXX of XXXX. I contacted Aspire by phone, made full payment to close this credit card. It took Aspire over one month to withdraw the final payment. Subsequently my closed Aspire cc incurred a penalty fee of {$190.00}. They sold it to a collections agency, XXXX XXXX and profited off this. XXXX XXXX has humanely worked with me but expect a XXXX payment. This should be a XXXX balance without profiting off collection sale of my cc account.
4th row	In accordance with the Fair Credit Reporting act. The List of accounts below has violated my federally protected consumer rights to privacy and confidentiality under 15 USC 1681. XXXX XXXX XXXX, XXXX XXXX XXXX XXXX XXXX, XXXX XXXX XXXX XXXX XXXX XXXX, has violated my rights. 15 U.S.C 1681 section 602 A. States I have the right to privacy. 15 U.S.C 1681 Section 604 A Section 2 : It also states a consumer reporting agency can not furnish a account without my written instructions 15 U.S.C 1681c. ( a ) ( 5 ) Section States : no consumer reporting agency may make any consumer report containing any of the following items of information Any other adverse item of information, other than records of convictions of crimes which antedates the report by more than seven years. 15 U.S.C. 1681s-2 ( A ) ( 1 ) A person shall not furnish any information relating to a consumer to any consumer reporting agency if the person knows or has reasonable cause to believe that the information is inaccurate.
5th row	My name is XXXX XXXX XXXX XXXX this complaint is not made in error neither is it being made by a third party.I declare under penalty of perjury I am alleging that a person or company- without my authorization- from unauthorized use of my social security number and card used my personal identifying information to apply for goods, services, or money ; and, was successful in creating some accounts. I have no knowledge of this and All is being investigated by the FTC.

Value	Count	Frequency (%)
xxxx	16726665	6.2%
the	10678845	4.0%
to	8583026	3.2%
i	8524732	3.2%
	7326672	2.7%
and	6777435	2.5%
my	5533615	2.0%
a	5531303	2.0%
of	4801245	1.8%
that	3782104	1.4%
Other values (348946)	192021867	71.0%

Most occurring characters

Value	Count	Frequency (%)
	269870005	17.9%
e	127845192	8.5%
t	103812614	6.9%
a	86110183	5.7%
X	84517321	5.6%
o	79771219	5.3%
n	77841701	5.2%
i	71396820	4.7%
r	62670696	4.2%
s	55970952	3.7%
Other values (120)	485355757	32.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1026996151	68.2%
Space Separator	269870477	17.9%
Uppercase Letter	147508769	9.8%
Other Punctuation	31230063	2.1%
Decimal Number	17268463	1.1%
Control	3366197	0.2%
Close Punctuation	3164024	0.2%
Open Punctuation	3090328	0.2%
Currency Symbol	1301139	0.1%
Dash Punctuation	1169957	0.1%
Other values (9)	196892	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	127845192	12.4%
t	103812614	10.1%
a	86110183	8.4%
o	79771219	7.8%
n	77841701	7.6%
i	71396820	7.0%
r	62670696	6.1%
s	55970952	5.4%
d	45449620	4.4%
h	44880667	4.4%
Other values (17)	271246487	26.4%

Uppercase Letter

Value	Count	Frequency (%)
X	84517321	57.3%
I	12086117	8.2%
T	6095525	4.1%
A	5428177	3.7%
C	4367773	3.0%
E	4293203	2.9%
S	3949723	2.7%
O	3197014	2.2%
N	3040971	2.1%
R	2839301	1.9%
Other values (16)	17693644	12.0%

Other Punctuation

Value	Count	Frequency (%)
.	14576506	46.7%
,	7135723	22.8%
/	4499957	14.4%
'	1816268	5.8%
:	1211168	3.9%
!	364679	1.2%
"	345370	1.1%
;	335049	1.1%
#	334645	1.1%
?	228300	0.7%
Other values (8)	382398	1.2%

Decimal Number

Value	Count	Frequency (%)
0	6226175	36.1%
1	3277279	19.0%
2	2165337	12.5%
6	1468341	8.5%
5	1158729	6.7%
3	831753	4.8%
8	791387	4.6%
4	566267	3.3%
9	467277	2.7%
7	315918	1.8%

Math Symbol

Value	Count	Frequency (%)
+	27507	27.2%
=	23836	23.6%
>	21944	21.7%
<	13663	13.5%
\|	9411	9.3%
~	4673	4.6%
−	6	< 0.1%
⦁	2	< 0.1%

Control

Value	Count	Frequency (%)
	3354447	99.7%
	11731	0.3%
	8	< 0.1%
	8	< 0.1%
	2	< 0.1%
	1	< 0.1%

Private Use

Value	Count	Frequency (%)
	17	50.0%
	10	29.4%
	3	8.8%
	2	5.9%
	1	2.9%
	1	2.9%

Space Separator

Value	Count	Frequency (%)
	269870005	> 99.9%
	464	< 0.1%
	5	< 0.1%
	2	< 0.1%
	1	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	1169573	> 99.9%
—	223	< 0.1%
–	160	< 0.1%
‐	1	< 0.1%

Close Punctuation

Value	Count	Frequency (%)
)	1887593	59.7%
}	1242911	39.3%
]	33520	1.1%

Open Punctuation

Value	Count	Frequency (%)
(	1813571	58.7%
{	1243349	40.2%
[	33408	1.1%

Format

Value	Count	Frequency (%)
‭	5	55.6%
‬	3	33.3%
‎	1	11.1%

Modifier Symbol

Value	Count	Frequency (%)
`	1823	53.5%
^	1587	46.5%

Final Punctuation

Value	Count	Frequency (%)
’	1166	70.2%
”	494	29.8%

Initial Punctuation

Value	Count	Frequency (%)
“	516	95.6%
‘	24	4.4%

Other Symbol

Value	Count	Frequency (%)
¦	2	50.0%
®	2	50.0%

Currency Symbol

Value	Count	Frequency (%)
$	1301139	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	90180	100.0%

Other Number

Value	Count	Frequency (%)
½	13	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1174504920	78.0%
Common	330657506	22.0%
Unknown	34	< 0.1%

Most frequent character per script

Common

Value	Count	Frequency (%)
	269870005	81.6%
.	14576506	4.4%
,	7135723	2.2%
0	6226175	1.9%
/	4499957	1.4%
	3354447	1.0%
1	3277279	1.0%
2	2165337	0.7%
)	1887593	0.6%
'	1816268	0.5%
Other values (61)	15848216	4.8%

Latin

Value	Count	Frequency (%)
e	127845192	10.9%
t	103812614	8.8%
a	86110183	7.3%
X	84517321	7.2%
o	79771219	6.8%
n	77841701	6.6%
i	71396820	6.1%
r	62670696	5.3%
s	55970952	4.8%
d	45449620	3.9%
Other values (43)	379118602	32.3%

Unknown

Value	Count	Frequency (%)
	17	50.0%
	10	29.4%
	3	8.8%
	2	5.9%
	1	2.9%
	1	2.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1505158853	> 99.9%
Punctuation	2904	< 0.1%
None	663	< 0.1%
PUA	34	< 0.1%
Math Operators	6	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	269870005	17.9%
e	127845192	8.5%
t	103812614	6.9%
a	86110183	5.7%
X	84517321	5.6%
o	79771219	5.3%
n	77841701	5.2%
i	71396820	4.7%
r	62670696	4.2%
s	55970952	3.7%
Other values (88)	485352150	32.2%

Punctuation

Value	Count	Frequency (%)
’	1166	40.2%
“	516	17.8%
”	494	17.0%
•	275	9.5%
—	223	7.7%
–	160	5.5%
…	28	1.0%
‘	24	0.8%
	5	0.2%
‭	5	0.2%
Other values (5)	8	0.3%

None

Value	Count	Frequency (%)
	464	70.0%
§	166	25.0%
½	13	2.0%
	8	1.2%
é	3	0.5%
⦁	2	0.3%
¦	2	0.3%
®	2	0.3%
	2	0.3%
	1	0.2%

PUA

Value	Count	Frequency (%)
	17	50.0%
	10	29.4%
	3	8.8%
	2	5.9%
	1	2.9%
	1	2.9%

Math Operators

Value	Count	Frequency (%)
−	6	100.0%

Company public response
Categorical

IMBALANCE MISSING

Distinct	11
Distinct (%)	< 0.1%
Missing	2168295
Missing (%)	53.8%
Memory size	30.7 MiB

Company has responded to the consumer and the CFPB and chooses not to provide a public response	1632907
Company believes it acted appropriately as authorized by contract or law	126657
Company chooses not to provide a public response	52473
Company believes the complaint is the result of a misunderstanding	12312
Company disputes the facts presented in the complaint	10035
Other values (6)	25851

Length

Max length	119
Median length	95
Mean length	91.570364
Min length	48

Characters and Unicode

Total characters	170342396
Distinct characters	29
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Company has responded to the consumer and the CFPB and chooses not to provide a public response
2nd row	Company has responded to the consumer and the CFPB and chooses not to provide a public response
3rd row	Company has responded to the consumer and the CFPB and chooses not to provide a public response
4th row	Company has responded to the consumer and the CFPB and chooses not to provide a public response
5th row	Company believes it acted appropriately as authorized by contract or law

Common Values

Value	Count	Frequency (%)
Company has responded to the consumer and the CFPB and chooses not to provide a public response	1632907	40.5%
Company believes it acted appropriately as authorized by contract or law	126657	3.1%
Company chooses not to provide a public response	52473	1.3%
Company believes the complaint is the result of a misunderstanding	12312	0.3%
Company disputes the facts presented in the complaint	10035	0.2%
Company believes complaint caused principally by actions of third party outside the control or direction of the company	7509	0.2%
Company believes complaint is the result of an isolated error	6068	0.2%
Company believes complaint represents an opportunity for improvement to better serve consumers	4562	0.1%
Company can't verify or dispute the facts in the complaint	4181	0.1%
Company believes the complaint provided an opportunity to answer consumer's questions	3423	0.1%
(Missing)	2168295	53.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
the	3343379	11.1%
to	3326380	11.0%
and	3265814	10.8%
company	1867744	6.2%
a	1697800	5.6%
provide	1685380	5.6%
response	1685380	5.6%
public	1685380	5.6%
chooses	1685380	5.6%
not	1685380	5.6%
Other values (52)	8178942	27.2%

Most occurring characters

Value	Count	Frequency (%)
	28246724	16.6%
o	17576790	10.3%
e	16019217	9.4%
s	12106159	7.1%
n	12086600	7.1%
a	9483459	5.6%
t	9325598	5.5%
p	9060471	5.3%
d	8562471	5.0%
r	7432826	4.4%
Other values (19)	40442081	23.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	133696205	78.5%
Space Separator	28246724	16.6%
Uppercase Letter	8391863	4.9%
Other Punctuation	7604	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	17576790	13.1%
e	16019217	12.0%
s	12106159	9.1%
n	12086600	9.0%
a	9483459	7.1%
t	9325598	7.0%
p	9060471	6.8%
d	8562471	6.4%
r	7432826	5.6%
h	6795832	5.1%
Other values (13)	25246782	18.9%

Uppercase Letter

Value	Count	Frequency (%)
C	3493142	41.6%
F	1632907	19.5%
P	1632907	19.5%
B	1632907	19.5%

Space Separator

Value	Count	Frequency (%)
	28246724	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	7604	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	142088068	83.4%
Common	28254328	16.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	17576790	12.4%
e	16019217	11.3%
s	12106159	8.5%
n	12086600	8.5%
a	9483459	6.7%
t	9325598	6.6%
p	9060471	6.4%
d	8562471	6.0%
r	7432826	5.2%
h	6795832	4.8%
Other values (17)	33638645	23.7%

Common

Value	Count	Frequency (%)
	28246724	> 99.9%
'	7604	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	170342396	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	28246724	16.6%
o	17576790	10.3%
e	16019217	9.4%
s	12106159	7.1%
n	12086600	7.1%
a	9483459	5.6%
t	9325598	5.5%
p	9060471	5.3%
d	8562471	5.0%
r	7432826	4.4%
Other values (19)	40442081	23.7%

Company
Text

Distinct	6909
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	30.7 MiB

Length

Max length	88
Median length	82
Mean length	26.272977
Min length	3

Characters and Unicode

Total characters	105841476
Distinct characters	84
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1361 ?
Unique (%)	< 0.1%

Sample

1st row	OneMain Finance Corporation
2nd row	Experian Information Solutions Inc.
3rd row	Maximus Education, LLC dba Aidvantage
4th row	CITIBANK, N.A.
5th row	FORD MOTOR CREDIT CO.

Value	Count	Frequency (%)
inc	2578789	18.9%
holdings	798561	5.9%
equifax	766683	5.6%
solutions	688499	5.0%
intermediate	686100	5.0%
transunion	681580	5.0%
information	632917	4.6%
experian	625425	4.6%
financial	345565	2.5%
llc	284748	2.1%
Other values (5623)	5559072	40.7%

Most occurring characters

Value	Count	Frequency (%)
	9618539	9.1%
I	8828965	8.3%
N	7718429	7.3%
A	5672474	5.4%
E	4801942	4.5%
n	4791785	4.5%
C	4159158	3.9%
O	3834939	3.6%
S	3630251	3.4%
o	3588799	3.4%
Other values (74)	49196195	46.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	60477593	57.1%
Lowercase Letter	30052007	28.4%
Space Separator	9619561	9.1%
Other Punctuation	5646993	5.3%
Open Punctuation	15819	< 0.1%
Close Punctuation	15819	< 0.1%
Dash Punctuation	8095	< 0.1%
Decimal Number	5491	< 0.1%
Final Punctuation	50	< 0.1%
Math Symbol	46	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	4791785	15.9%
o	3588799	11.9%
i	3143413	10.5%
a	2440959	8.1%
r	2185622	7.3%
e	2084557	6.9%
t	2084333	6.9%
c	1577410	5.2%
s	1374678	4.6%
l	1322148	4.4%
Other values (18)	5458303	18.2%

Uppercase Letter

Value	Count	Frequency (%)
I	8828965	14.6%
N	7718429	12.8%
A	5672474	9.4%
E	4801942	7.9%
C	4159158	6.9%
O	3834939	6.3%
S	3630251	6.0%
T	3310043	5.5%
R	2951304	4.9%
L	2399425	4.0%
Other values (16)	13170663	21.8%

Other Punctuation

Value	Count	Frequency (%)
.	3062191	54.2%
,	2277033	40.3%
&	277313	4.9%
/	25483	0.5%
'	4378	0.1%
*	323	< 0.1%
"	240	< 0.1%
:	28	< 0.1%
\	2	< 0.1%
!	2	< 0.1%

Decimal Number

Value	Count	Frequency (%)
2	1895	34.5%
1	1858	33.8%
8	520	9.5%
3	277	5.0%
4	245	4.5%
6	215	3.9%
0	200	3.6%
9	199	3.6%
5	61	1.1%
7	21	0.4%

Space Separator

Value	Count	Frequency (%)
	9618539	> 99.9%
	1022	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	7964	98.4%
—	131	1.6%

Math Symbol

Value	Count	Frequency (%)
+	28	60.9%
\|	18	39.1%

Open Punctuation

Value	Count	Frequency (%)
(	15819	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	15819	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	50	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	90529600	85.5%
Common	15311876	14.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	8828965	9.8%
N	7718429	8.5%
A	5672474	6.3%
E	4801942	5.3%
n	4791785	5.3%
C	4159158	4.6%
O	3834939	4.2%
S	3630251	4.0%
o	3588799	4.0%
T	3310043	3.7%
Other values (44)	40192815	44.4%

Common

Value	Count	Frequency (%)
	9618539	62.8%
.	3062191	20.0%
,	2277033	14.9%
&	277313	1.8%
/	25483	0.2%
(	15819	0.1%
)	15819	0.1%
-	7964	0.1%
'	4378	< 0.1%
2	1895	< 0.1%
Other values (20)	5442	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	105839933	> 99.9%
None	1362	< 0.1%
Punctuation	181	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	9618539	9.1%
I	8828965	8.3%
N	7718429	7.3%
A	5672474	5.4%
E	4801942	4.5%
n	4791785	4.5%
C	4159158	3.9%
O	3834939	3.6%
S	3630251	3.4%
o	3588799	3.4%
Other values (69)	49194652	46.5%

None

Value	Count	Frequency (%)
	1022	75.0%
à	339	24.9%
é	1	0.1%

Punctuation

Value	Count	Frequency (%)
—	131	72.4%
’	50	27.6%

State
Text

MISSING

Distinct	63
Distinct (%)	< 0.1%
Missing	43121
Missing (%)	1.1%
Memory size	30.7 MiB

Length

Max length	36
Median length	2
Mean length	2.0030115
Min length	2

Characters and Unicode

Total characters	7982820
Distinct characters	25
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NC
2nd row	GA
3rd row	OH
4th row	KY
5th row	FL

Value	Count	Frequency (%)
ca	471202	11.8%
fl	464118	11.6%
tx	411218	10.3%
ga	267910	6.7%
ny	258490	6.5%
pa	187765	4.7%
il	160862	4.0%
nj	135529	3.4%
nc	132215	3.3%
md	106871	2.7%
Other values (57)	1390641	34.9%

Most occurring characters

Value	Count	Frequency (%)
A	1401948	17.6%
C	774065	9.7%
L	771167	9.7%
N	768305	9.6%
T	551156	6.9%
F	464233	5.8%
X	411218	5.2%
M	399750	5.0%
I	368746	4.6%
Y	283309	3.5%
Other values (15)	1788923	22.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	7981408	> 99.9%
Space Separator	1412	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	1401948	17.6%
C	774065	9.7%
L	771167	9.7%
N	768305	9.6%
T	551156	6.9%
F	464233	5.8%
X	411218	5.2%
M	399750	5.0%
I	368746	4.6%
Y	283309	3.5%
Other values (14)	1787511	22.4%

Space Separator

Value	Count	Frequency (%)
	1412	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7981408	> 99.9%
Common	1412	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	1401948	17.6%
C	774065	9.7%
L	771167	9.7%
N	768305	9.6%
T	551156	6.9%
F	464233	5.8%
X	411218	5.2%
M	399750	5.0%
I	368746	4.6%
Y	283309	3.5%
Other values (14)	1787511	22.4%

Common

Value	Count	Frequency (%)
	1412	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7982820	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	1401948	17.6%
C	774065	9.7%
L	771167	9.7%
N	768305	9.6%
T	551156	6.9%
F	464233	5.8%
X	411218	5.2%
M	399750	5.0%
I	368746	4.6%
Y	283309	3.5%
Other values (15)	1788923	22.4%

ZIP code
Text

Distinct	33059
Distinct (%)	0.8%
Missing	30208
Missing (%)	0.7%
Memory size	30.7 MiB

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	19991610
Distinct characters	21
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5960 ?
Unique (%)	0.1%

Sample

1st row	27407
2nd row	30318
3rd row	43035
4th row	41018
5th row	336XX

Value	Count	Frequency (%)
xxxxx	100549	2.5%
30349	7164	0.2%
35405	5616	0.1%
19143	5341	0.1%
33025	5144	0.1%
77449	5051	0.1%
33311	4726	0.1%
604xx	4641	0.1%
19120	4626	0.1%
30331	4514	0.1%
Other values (33050)	3850951	96.3%

Most occurring characters

Value	Count	Frequency (%)
0	2869793	14.4%
3	2537205	12.7%
1	2430797	12.2%
2	2151054	10.8%
7	1734932	8.7%
4	1604407	8.0%
9	1440240	7.2%
5	1385922	6.9%
6	1368121	6.8%
8	1301452	6.5%
Other values (11)	1167687	5.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	18823923	94.2%
Uppercase Letter	1167611	5.8%
Dash Punctuation	57	< 0.1%
Other Punctuation	7	< 0.1%
Modifier Symbol	3	< 0.1%
Currency Symbol	3	< 0.1%
Open Punctuation	3	< 0.1%
Math Symbol	2	< 0.1%
Space Separator	1	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2869793	15.2%
3	2537205	13.5%
1	2430797	12.9%
2	2151054	11.4%
7	1734932	9.2%
4	1604407	8.5%
9	1440240	7.7%
5	1385922	7.4%
6	1368121	7.3%
8	1301452	6.9%

Other Punctuation

Value	Count	Frequency (%)
*	3	42.9%
/	2	28.6%
.	1	14.3%
!	1	14.3%

Uppercase Letter

Value	Count	Frequency (%)
X	1167611	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	57	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	3	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	3	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	3	100.0%

Math Symbol

Value	Count	Frequency (%)
+	2	100.0%

Space Separator

Value	Count	Frequency (%)
	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	18823999	94.2%
Latin	1167611	5.8%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2869793	15.2%
3	2537205	13.5%
1	2430797	12.9%
2	2151054	11.4%
7	1734932	9.2%
4	1604407	8.5%
9	1440240	7.7%
5	1385922	7.4%
6	1368121	7.3%
8	1301452	6.9%
Other values (10)	76	< 0.1%

Latin

Value	Count	Frequency (%)
X	1167611	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	19991610	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2869793	14.4%
3	2537205	12.7%
1	2430797	12.2%
2	2151054	10.8%
7	1734932	8.7%
4	1604407	8.0%
9	1440240	7.2%
5	1385922	6.9%
6	1368121	6.8%
8	1301452	6.5%
Other values (11)	1167687	5.8%

Tags
Categorical

MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	3605729
Missing (%)	89.5%
Memory size	30.7 MiB

Servicemember	244428
Older American	143587
Older American, Servicemember	34786

Length

Max length	29
Median length	13
Mean length	14.656011
Min length	13

Characters and Unicode

Total characters	6196576
Distinct characters	16
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Servicemember
2nd row	Older American
3rd row	Servicemember
4th row	Servicemember
5th row	Servicemember

Common Values

Value	Count	Frequency (%)
Servicemember	244428	6.1%
Older American	143587	3.6%
Older American, Servicemember	34786	0.9%
(Missing)	3605729	89.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
servicemember	279214	43.9%
older	178373	28.0%
american	178373	28.0%

Most occurring characters

Value	Count	Frequency (%)
e	1473602	23.8%
r	915174	14.8%
m	736801	11.9%
i	457587	7.4%
c	457587	7.4%
S	279214	4.5%
v	279214	4.5%
b	279214	4.5%
	213159	3.4%
O	178373	2.9%
Other values (6)	926651	15.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5312671	85.7%
Uppercase Letter	635960	10.3%
Space Separator	213159	3.4%
Other Punctuation	34786	0.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1473602	27.7%
r	915174	17.2%
m	736801	13.9%
i	457587	8.6%
c	457587	8.6%
v	279214	5.3%
b	279214	5.3%
l	178373	3.4%
d	178373	3.4%
a	178373	3.4%

Uppercase Letter

Value	Count	Frequency (%)
S	279214	43.9%
O	178373	28.0%
A	178373	28.0%

Space Separator

Value	Count	Frequency (%)
	213159	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	34786	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5948631	96.0%
Common	247945	4.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1473602	24.8%
r	915174	15.4%
m	736801	12.4%
i	457587	7.7%
c	457587	7.7%
S	279214	4.7%
v	279214	4.7%
b	279214	4.7%
O	178373	3.0%
l	178373	3.0%
Other values (4)	713492	12.0%

Common

Value	Count	Frequency (%)
	213159	86.0%
,	34786	14.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6196576	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1473602	23.8%
r	915174	14.8%
m	736801	11.9%
i	457587	7.4%
c	457587	7.4%
S	279214	4.5%
v	279214	4.5%
b	279214	4.5%
	213159	3.4%
O	178373	2.9%
Other values (6)	926651	15.0%

Consumer consent provided?
Categorical

MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	896805
Missing (%)	22.3%
Memory size	30.7 MiB

Consent not provided	1517667
Consent provided	1460821
Other	146024
Consent withdrawn	7213

Length

Max length	20
Median length	17
Mean length	17.427845
Min length	5

Characters and Unicode

Total characters	54579217
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Consent not provided
2nd row	Other
3rd row	Consent provided
4th row	Consent provided
5th row	Other

Common Values

Value	Count	Frequency (%)
Consent not provided	1517667	37.7%
Consent provided	1460821	36.3%
Other	146024	3.6%
Consent withdrawn	7213	0.2%
(Missing)	896805	22.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
consent	2985701	39.1%
provided	2978488	39.0%
not	1517667	19.9%
other	146024	1.9%
withdrawn	7213	0.1%

Most occurring characters

Value	Count	Frequency (%)
n	7496282	13.7%
o	7481856	13.7%
e	6110213	11.2%
d	5964189	10.9%
t	4656605	8.5%
	4503368	8.3%
r	3131725	5.7%
C	2985701	5.5%
s	2985701	5.5%
i	2985701	5.5%
Other values (6)	6277876	11.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	46944124	86.0%
Space Separator	4503368	8.3%
Uppercase Letter	3131725	5.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	7496282	16.0%
o	7481856	15.9%
e	6110213	13.0%
d	5964189	12.7%
t	4656605	9.9%
r	3131725	6.7%
s	2985701	6.4%
i	2985701	6.4%
p	2978488	6.3%
v	2978488	6.3%
Other values (3)	174876	0.4%

Uppercase Letter

Value	Count	Frequency (%)
C	2985701	95.3%
O	146024	4.7%

Space Separator

Value	Count	Frequency (%)
	4503368	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	50075849	91.7%
Common	4503368	8.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	7496282	15.0%
o	7481856	14.9%
e	6110213	12.2%
d	5964189	11.9%
t	4656605	9.3%
r	3131725	6.3%
C	2985701	6.0%
s	2985701	6.0%
i	2985701	6.0%
p	2978488	5.9%
Other values (5)	3299388	6.6%

Common

Value	Count	Frequency (%)
	4503368	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	54579217	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	7496282	13.7%
o	7481856	13.7%
e	6110213	11.2%
d	5964189	10.9%
t	4656605	8.5%
	4503368	8.3%
r	3131725	5.7%
C	2985701	5.5%
s	2985701	5.5%
i	2985701	5.5%
Other values (6)	6277876	11.5%

Submitted via
Categorical

IMBALANCE

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	30.7 MiB

Web	3503766
Referral	242366
Phone	164988
Postal mail	90089
Fax	25658
Other values (2)	1663

Length

Max length	12
Median length	3
Mean length	3.5646005
Min length	3

Characters and Unicode

Total characters	14360100
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Web
2nd row	Web
3rd row	Web
4th row	Phone
5th row	Web

Common Values

Value	Count	Frequency (%)
Web	3503766	87.0%
Referral	242366	6.0%
Phone	164988	4.1%
Postal mail	90089	2.2%
Fax	25658	0.6%
Web Referral	1238	< 0.1%
Email	425	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
web	3505004	85.1%
referral	243604	5.9%
phone	164988	4.0%
postal	90089	2.2%
mail	90089	2.2%
fax	25658	0.6%
email	425	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	4157200	28.9%
W	3505004	24.4%
b	3505004	24.4%
r	487208	3.4%
a	449865	3.1%
l	424207	3.0%
P	255077	1.8%
o	255077	1.8%
f	243604	1.7%
R	243604	1.7%
Other values (10)	834250	5.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	10239005	71.3%
Uppercase Letter	4029768	28.1%
Space Separator	91327	0.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	4157200	40.6%
b	3505004	34.2%
r	487208	4.8%
a	449865	4.4%
l	424207	4.1%
o	255077	2.5%
f	243604	2.4%
h	164988	1.6%
n	164988	1.6%
m	90514	0.9%
Other values (4)	296350	2.9%

Uppercase Letter

Value	Count	Frequency (%)
W	3505004	87.0%
P	255077	6.3%
R	243604	6.0%
F	25658	0.6%
E	425	< 0.1%

Space Separator

Value	Count	Frequency (%)
	91327	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14268773	99.4%
Common	91327	0.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	4157200	29.1%
W	3505004	24.6%
b	3505004	24.6%
r	487208	3.4%
a	449865	3.2%
l	424207	3.0%
P	255077	1.8%
o	255077	1.8%
f	243604	1.7%
R	243604	1.7%
Other values (9)	742923	5.2%

Common

Value	Count	Frequency (%)
	91327	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14360100	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	4157200	28.9%
W	3505004	24.4%
b	3505004	24.4%
r	487208	3.4%
a	449865	3.1%
l	424207	3.0%
P	255077	1.8%
o	255077	1.8%
f	243604	1.7%
R	243604	1.7%
Other values (10)	834250	5.8%

Date sent to company
Date

Distinct	4244
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	30.7 MiB

Minimum	2011-12-01 00:00:00
Maximum	2023-09-05 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Company response to consumer
Categorical

IMBALANCE

Distinct	8
Distinct (%)	< 0.1%
Missing	5
Missing (%)	< 0.1%
Memory size	30.7 MiB

Closed with explanation	2934815
Closed with non-monetary relief	795130
Closed with monetary relief	137963
In progress	110474
Closed without relief	17868
Other values (3)	32275

Length

Max length	31
Median length	23
Mean length	24.283199
Min length	6

Characters and Unicode

Total characters	97825476
Distinct characters	24
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Closed with explanation
2nd row	Closed with non-monetary relief
3rd row	Closed with explanation
4th row	Closed with explanation
5th row	In progress

Common Values

Value	Count	Frequency (%)
Closed with explanation	2934815	72.9%
Closed with non-monetary relief	795130	19.7%
Closed with monetary relief	137963	3.4%
In progress	110474	2.7%
Closed without relief	17868	0.4%
Closed	17611	0.4%
Untimely response	9360	0.2%
Closed with relief	5304	0.1%
(Missing)	5	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
closed	3908691	30.4%
with	3873212	30.1%
explanation	2934815	22.8%
relief	956265	7.4%
non-monetary	795130	6.2%
monetary	137963	1.1%
in	110474	0.9%
progress	110474	0.9%
without	17868	0.1%
untimely	9360	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	9827683	10.0%
	8835087	9.0%
o	8709431	8.9%
n	8522177	8.7%
l	7809131	8.0%
i	7791520	8.0%
t	7786216	8.0%
a	6802723	7.0%
s	4148359	4.2%
C	3908691	4.0%
Other values (14)	23684458	24.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	84166734	86.0%
Space Separator	8835087	9.0%
Uppercase Letter	4028525	4.1%
Dash Punctuation	795130	0.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	9827683	11.7%
o	8709431	10.3%
n	8522177	10.1%
l	7809131	9.3%
i	7791520	9.3%
t	7786216	9.3%
a	6802723	8.1%
s	4148359	4.9%
d	3908691	4.6%
w	3891080	4.6%
Other values (9)	14969723	17.8%

Uppercase Letter

Value	Count	Frequency (%)
C	3908691	97.0%
I	110474	2.7%
U	9360	0.2%

Space Separator

Value	Count	Frequency (%)
	8835087	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	795130	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	88195259	90.2%
Common	9630217	9.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	9827683	11.1%
o	8709431	9.9%
n	8522177	9.7%
l	7809131	8.9%
i	7791520	8.8%
t	7786216	8.8%
a	6802723	7.7%
s	4148359	4.7%
C	3908691	4.4%
d	3908691	4.4%
Other values (12)	18980637	21.5%

Common

Value	Count	Frequency (%)
	8835087	91.7%
-	795130	8.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	97825476	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	9827683	10.0%
	8835087	9.0%
o	8709431	8.9%
n	8522177	8.7%
l	7809131	8.0%
i	7791520	8.0%
t	7786216	8.0%
a	6802723	7.0%
s	4148359	4.2%
C	3908691	4.0%
Other values (14)	23684458	24.2%

Timely response?
Boolean

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.8 MiB

True	3974796
False	53734

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	3974796	98.7%
False	53734	1.3%

Consumer disputed?
Boolean

MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	3260172
Missing (%)	80.9%
Memory size	7.7 MiB

False	619980
True	148378
(Missing)	3260172

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	619980	15.4%
True	148378	3.7%
(Missing)	3260172	80.9%

Complaint ID
Real number (ℝ)

UNIQUE

Distinct	4028530
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4293194.3

Minimum	1
Maximum	7499298
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	30.7 MiB

Quantile statistics

Minimum	1
5-th percentile	714311.45
Q1	2859701.2
median	4217975.5
Q3	6104681.8
95-th percentile	7210740.5
Maximum	7499298
Range	7499297
Interquartile range (IQR)	3244980.5

Descriptive statistics

Standard deviation	2013775.2
Coefficient of variation (CV)	0.46906221
Kurtosis	-0.95929452
Mean	4293194.3
Median Absolute Deviation (MAD)	1622297
Skewness	-0.22487774
Sum	1.7295262 × 10¹³
Variance	4.0552905 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7448359	1	< 0.1%
4006712	1	< 0.1%
3973369	1	< 0.1%
6321782	1	< 0.1%
3071340	1	< 0.1%
4006711	1	< 0.1%
3388381	1	< 0.1%
4004342	1	< 0.1%
3858239	1	< 0.1%
2635229	1	< 0.1%
Other values (4028520)	4028520	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
5	1	< 0.1%
7	1	< 0.1%
16	1	< 0.1%
20	1	< 0.1%
22	1	< 0.1%
24	1	< 0.1%
26	1	< 0.1%
27	1	< 0.1%
36	1	< 0.1%

Value	Count	Frequency (%)
7499298	1	< 0.1%
7499289	1	< 0.1%
7499284	1	< 0.1%
7499270	1	< 0.1%
7499260	1	< 0.1%
7499252	1	< 0.1%
7499232	1	< 0.1%
7499228	1	< 0.1%
7499226	1	< 0.1%
7499222	1	< 0.1%

Complaint ID

Complaint ID

Auto

Heatmap
Table

	Complaint ID	Product	Company public response	Tags	Consumer consent provided?	Submitted via	Company response to consumer	Timely response?	Consumer disputed?
Complaint ID	1.000	0.288	0.227	0.201	0.106	0.147	0.237	0.077	0.051
Product	0.288	1.000	0.224	0.289	0.143	0.184	0.238	0.131	0.067
Company public response	0.227	0.224	1.000	0.109	0.054	0.054	0.125	0.094	0.071
Tags	0.201	0.289	0.109	1.000	0.074	0.197	0.107	0.001	0.008
Consumer consent provided?	0.106	0.143	0.054	0.074	1.000	0.009	0.153	0.031	0.053
Submitted via	0.147	0.184	0.054	0.197	0.009	1.000	0.078	0.021	0.068
Company response to consumer	0.237	0.238	0.125	0.107	0.153	0.078	1.000	0.420	0.108
Timely response?	0.077	0.131	0.094	0.001	0.031	0.021	0.420	1.000	0.031
Consumer disputed?	0.051	0.067	0.071	0.008	0.053	0.068	0.108	0.031	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Date received	Product	Sub-product	Issue	Sub-issue	Consumer complaint narrative	Company public response	Company	State	ZIP code	Tags	Consumer consent provided?	Submitted via	Date sent to company	Company response to consumer	Timely response?	Consumer disputed?	Complaint ID
0	2023-08-23	Payday loan, title loan, or personal loan	Installment loan	Problem when making payments	NaN	NaN	NaN	OneMain Finance Corporation	NC	27407	NaN	NaN	Web	2023-08-23	Closed with explanation	Yes	NaN	7448359
1	2023-08-23	Credit reporting, credit repair services, or other personal consumer reports	Credit reporting	Incorrect information on your report	Account information incorrect	NaN	Company has responded to the consumer and the CFPB and chooses not to provide a public response	Experian Information Solutions Inc.	GA	30318	NaN	Consent not provided	Web	2023-08-23	Closed with non-monetary relief	Yes	NaN	7442747
2	2023-08-23	Credit reporting, credit repair services, or other personal consumer reports	Credit reporting	Improper use of your report	Reporting company used your report improperly	NaN	NaN	Maximus Education, LLC dba Aidvantage	OH	43035	Servicemember	NaN	Web	2023-08-23	Closed with explanation	Yes	NaN	7442667
3	2023-08-23	Credit card or prepaid card	Store credit card	Fees or interest	Charged too much interest	NaN	Company has responded to the consumer and the CFPB and chooses not to provide a public response	CITIBANK, N.A.	KY	41018	Older American	NaN	Phone	2023-08-23	Closed with explanation	Yes	NaN	7442765
4	2023-08-23	Credit reporting, credit repair services, or other personal consumer reports	Credit reporting	Problem with a credit reporting company's investigation into an existing problem	Their investigation did not fix an error on your report	NaN	NaN	FORD MOTOR CREDIT CO.	FL	336XX	NaN	NaN	Web	2023-08-23	In progress	Yes	NaN	7448366
5	2023-08-23	Debt collection	Other debt	False statements or representation	Attempted to collect wrong amount	NaN	NaN	LTD Financial Services, L.P.	NJ	08046	Servicemember	NaN	Web	2023-08-23	In progress	Yes	NaN	7447784
6	2023-08-23	Credit reporting, credit repair services, or other personal consumer reports	Credit reporting	Incorrect information on your report	Information belongs to someone else	NaN	NaN	SET Financial Corporation	MO	64118	NaN	NaN	Web	2023-08-23	Closed with explanation	Yes	NaN	7442577
7	2023-08-23	Debt collection	I do not know	Written notification about debt	Didn't receive enough information to verify debt	NaN	NaN	URS Holding, LLC	VA	23692	NaN	NaN	Web	2023-08-23	Closed with explanation	Yes	NaN	7443242
8	2023-08-23	Credit reporting, credit repair services, or other personal consumer reports	Credit reporting	Problem with a credit reporting company's investigation into an existing problem	Difficulty submitting a dispute or getting information about a dispute over the phone	NaN	NaN	Experian Information Solutions Inc.	NY	10928	NaN	NaN	Web	2023-08-23	In progress	Yes	NaN	7443333
9	2023-08-23	Credit reporting, credit repair services, or other personal consumer reports	Credit reporting	Improper use of your report	Credit inquiries on your report that you don't recognize	NaN	NaN	FORD MOTOR CREDIT CO.	KS	66441	NaN	NaN	Web	2023-08-23	In progress	Yes	NaN	7448042

	Date received	Product	Sub-product	Issue	Sub-issue	Consumer complaint narrative	Company public response	Company	State	ZIP code	Tags	Consumer consent provided?	Submitted via	Date sent to company	Company response to consumer	Timely response?	Consumer disputed?	Complaint ID
4028520	2022-08-15	Checking or savings account	Checking account	Managing an account	Deposits and withdrawals	NaN	NaN	JPMORGAN CHASE & CO.	CA	91902	NaN	NaN	Phone	2022-08-15	Closed with explanation	Yes	NaN	5880622
4028521	2012-09-27	Credit card	NaN	Advertising and marketing	NaN	NaN	NaN	DISCOVER BANK	TX	75238	NaN	NaN	Web	2012-09-27	Closed with explanation	Yes	No	160482
4028522	2015-07-16	Credit card	NaN	APR or interest rate	NaN	NaN	Company chooses not to provide a public response	BARCLAYS BANK DELAWARE	IL	60417	NaN	Consent not provided	Web	2015-07-16	Closed with non-monetary relief	Yes	No	1470975
4028523	2022-08-16	Debt collection	Other debt	Attempts to collect debt not owed	Debt is not yours	NaN	NaN	CONTRACT CALLERS INC	VA	23223	NaN	Consent not provided	Web	2022-08-16	Closed with explanation	Yes	NaN	5882345
4028524	2022-08-13	Debt collection	Other debt	Attempts to collect debt not owed	Debt is not yours	NaN	NaN	AFNI INC.	FL	33647	NaN	Consent not provided	Web	2022-08-13	Closed with explanation	Yes	NaN	5875635
4028525	2015-02-21	Credit card	NaN	Sale of account	NaN	NaN	NaN	JPMORGAN CHASE & CO.	AL	36695	NaN	NaN	Web	2015-02-21	Closed with explanation	Yes	Yes	1250605
4028526	2015-07-19	Credit reporting	NaN	Incorrect information on credit report	Account status	NaN	NaN	EQUIFAX, INC.	IL	60614	NaN	Consent not provided	Web	2015-07-19	Closed with explanation	Yes	No	1473577
4028527	2022-06-16	Mortgage	Conventional home mortgage	Applying for a mortgage or refinancing an existing mortgage	NaN	NaN	NaN	Mr. Cooper Group Inc.	IA	52205	NaN	NaN	Referral	2022-06-17	Closed with explanation	Yes	NaN	5683655
4028528	2022-04-26	Debt collection	I do not know	Attempts to collect debt not owed	Debt is not yours	NaN	NaN	V and H Portfolio	SC	29624	NaN	Consent not provided	Web	2022-04-26	Closed with non-monetary relief	Yes	NaN	5495755
4028529	2022-08-15	Checking or savings account	Checking account	Managing an account	Deposits and withdrawals	NaN	NaN	JPMORGAN CHASE & CO.	PA	17972	Older American	NaN	Phone	2022-08-15	Closed with explanation	Yes	NaN	5879503

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Final Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Punctuation

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Decimal Number

Math Symbol

Control

Private Use

Space Separator

Dash Punctuation